<?php
session_start();
/*
 * Session variables:
 * $_SESSION['type'] [string] = user type of the logged in user
 * $_SESSION['authorised'] [boolean] = whether or not the current user is logged in
 */
if(isset($_SESSION['authorised']) && $_SESSION['authorised'] == true)
{   
    if(isset($_SESSION['type']))
    {
        if($_SESSION['type'] == 'administrator')
        {
           ?>
<html xmlns="http://www.w3.org/1999/xhtml">
<head>
<meta http-equiv="Content-Type" content="text/html; charset=utf-8" />
<title>Manage Rooms</title>
<link href="StyleSheet.css" rel="stylesheet" type="text/css" />
<style>
.nav { 
	  width:210px;
	  height:auto;
	  border:thin solid #09C;
	  margin-left: 10px;
	  text-align : center;}
	  
.mainline { 
	  width:712px;
	  height:auto;
	  text-align : center;}


</style></head>
<center>
<body bgcolor="#FFFFFF">
<body>

<div id="wrapper">
	<div id="header">
    <h1></h1>
    </div>
    
    <div id="header2">
    	<h3></h3>
 	</div>
  
	<div id="nav">
       <?php include 'admin_navigation.php';?>
    </div>
	
    <div id="mainline">
        <h4>View Floor</h4>
    <?php
    	$building_id=$_SESSION['view_building'];
		$floor_id = $_SESSION['view_floor'];
		
		if($floor_id=='1')
		{
			$floor='1st';	
		}
		elseif($floor_id=='2')
		{
			$floor='2nd';	
		}
		elseif($floor_id=='3')
		{
			$floor='3rd';	
		}
		else
		{
			$floor=$floor_id.'th';
		}
    ?>
	
  <div id="body">
  <?php echo "<h3>$floor Floor</h3>"; ?>
  <form action=admin_roomaction.php method=POST>	
    <table width="700" height="auto" cellpadding="3" cellspacing="1" align="center">
        <tr height="40" bgcolor="LightSteelBlue">
            <th>Room Number</th>
            <th>Room Name</th>
            <th>Capacity</th>
            <th>Action</th>
        </tr>
        <?php 
            include ('connection.inc');
        
	        $sql = "SELECT * FROM rooms where building_id='$building_id' and floor='$floor_id' order by room_number";
	        $result = pg_query($sql);
        	$count = pg_num_rows($result);
            if($count<1)
            {
            	echo "</table>";
            	echo "<br>No rooms";
            }
            else{
			for($i = 0; $i <$count; $i++)
			{
	            $room_num =pg_fetch_result($result, $i, 'room_number');
	            $room_name =pg_fetch_result($result, $i, 'room_name');
	            $room_id =pg_fetch_result($result, $i, 'room_id');
	            $capacity =pg_fetch_result($result, $i, 'capacity');
	            echo "<tr height=\"30\" bgcolor=\"#f5f5f5\"><td><center>$room_num</center></td><td><center>$room_name</center></td>
	            <td><center>$capacity</center></td><td><center>
	            <input type=submit name=\"action\" value=\"Edit Room $room_id\"  />
				<input type=submit name=\"action\" value=\"Delete Room $room_id\"  />
	            </center>
	            </td>
	            </tr>";
	        }
	            echo "</table>";
            }

			?>
  		</form><br>
  		<center><table>
      <tr>
      <td><form action=admin_createroom.php method=POST>
  		<input type=submit name="add" value="Add Room"  />
  		</form></td><td>
  		<form action=admin_viewbuilding.php method=POST>
  		<input type=submit name="add" value="View Building"  />
  		</form></td>
  		</tr>
  		</table></center>
    </div>
    
    <br class="clearfloat">
	<br />
    </div>
    <div id="footer">
    <p align="center">
    Tutorial Business Manager: info@tbms.com <br />Credits/Engineers: Aquino, Chloebelle; Dela Cruz, Roy Erwin; Maliwanag, Ranyel Bryan; Manzano, Audrey Ann; Ng, Sheila Regine<br />
    <br />copyright 2011</p>
    </div>
</div>
</body>
</html>            
           <?php 

        }
        elseif($_SESSION['type'] == 'student')
         {
            header('Location: student_index.php');
            exit();
        }
        elseif($_SESSION['type'] == 'tutor')
        {
            header('Location: tutor_index.php');
            exit();
        }
        elseif($_SESSION['type'] == 'parent')
        {
            header('Location: parent_index.php');
            exit();
        }
    }
}
else
{
    header('Location: index.php');
}
?>

